package com.chey.dao;

import com.chey.domain.Arpt;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author JanYao
 * @version 0.1
 */@Mapper
public interface ArptDao {

    @Select("SELECT AIRL_ARPT_ID FROM DFOE_DFDL_DFLT WHERE DFLT_FLID=#{flid} AND DFLT_CFNO=#{apno}")
    public List<String> findArptUUID(String flid , String apno);

    @Select("select * from ARPTS where AIRL_ARPT_ID=#{uuid}")
    public List<Arpt> findArptS(String uuid);


    @Select("select * from ARPTS where AIRL_ARPT_ID=#{uuid}")
    public List<Arpt> findArptE(String uuid);

    @Select("update ARPTS set FPTT=#{startTime} where AIRL_ARPT_ID=#{uuid}")
    public Integer updateS(String startTime ,String uuid);

    @Select("update ARPTE set FPLT=#{endTime} where AIRL_ARPT_ID=#{uuid}")
    public Integer updateE(String endTime ,String uuid);

    @Select("select * from TRANSFER where id=#{uuid}")
    public List<Arpt> findArptT(String uuid);
}
